
[dbo].[asi_GetWorkItemLockDuration]
create function [dbo].[asi_GetWorkItemLockDuration]()
returns int
as
begin
declare @duration int
select @duration = convert(int, ParameterValue)
from SystemConfig
where ParameterName = 'WorkItemLockDuration'
if @duration is null
set @duration = 10
return(@duration)
end
GO